Tabela NFZEpisodeData

Definicja tabeli NFZEpisodeData

Name

NFZEpisodeData

Code

NFZEpisodeData

Comment

 


Lista kolumn tabeli NFZEpisodeData

Name

Code

NumberOfMonthSinceFallingIll

NumberOfMonthSinceFallingIll

LastDischargeDate

LastDischargeDate

BarthelADL

BarthelADL

ASIA

ASIA

GMFCS

GMFCS

MainICDID

MainICDID

Coexistent1ICDID

Coexistent1ICDID

Coexistent2ICDID

Coexistent2ICDID

Coexistent3ICDID

Coexistent3ICDID

Coexistent4ICDID

Coexistent4ICDID

Coexistent5ICDID

Coexistent5ICDID

ComaRecoveryDT

ComaRecoveryDT

RehabAdmissionDT

RehabAdmissionDT

AdmissionBedsores

AdmissionBedsores

DischargeBedsores

DischargeBedsores

RankinScale

RankinScale

ScaldDegree

ScaldDegree

CardioLVef

CardioLVef

ICD9ID

ICD9ID

ICD10ID

ICD10ID

RehabilitationTypeID

RehabilitationTypeID

NyhaScaleID

NyhaScaleID

NyhaScaleCode

NyhaScaleCode

HasInfection

HasInfection

InfectionICDID

InfectionICDID


Kolumna NumberOfMonthSinceFallingIll tabeli NFZEpisodeData

Definicja kolumny NumberOfMonthSinceFallingIll tabeli NFZEpisodeData

Name

NumberOfMonthSinceFallingIll

Code

NumberOfMonthSinceFallingIll

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna LastDischargeDate tabeli NFZEpisodeData

Definicja kolumny LastDischargeDate tabeli NFZEpisodeData

Name

LastDischargeDate

Code

LastDischargeDate

Data Type

DATE

Mandatory

No

Comment

 


Kolumna BarthelADL tabeli NFZEpisodeData

Definicja kolumny BarthelADL tabeli NFZEpisodeData

Name

BarthelADL

Code

BarthelADL

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna ASIA tabeli NFZEpisodeData

Definicja kolumny ASIA tabeli NFZEpisodeData

Name

ASIA

Code

ASIA

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna GMFCS tabeli NFZEpisodeData

Definicja kolumny GMFCS tabeli NFZEpisodeData

Name

GMFCS

Code

GMFCS

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna MainICDID tabeli NFZEpisodeData

Definicja kolumny MainICDID tabeli NFZEpisodeData

Name

MainICDID

Code

MainICDID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Coexistent1ICDID tabeli NFZEpisodeData

Definicja kolumny Coexistent1ICDID tabeli NFZEpisodeData

Name

Coexistent1ICDID

Code

Coexistent1ICDID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Coexistent2ICDID tabeli NFZEpisodeData

Definicja kolumny Coexistent2ICDID tabeli NFZEpisodeData

Name

Coexistent2ICDID

Code

Coexistent2ICDID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Coexistent3ICDID tabeli NFZEpisodeData

Definicja kolumny Coexistent3ICDID tabeli NFZEpisodeData

Name

Coexistent3ICDID

Code

Coexistent3ICDID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Coexistent4ICDID tabeli NFZEpisodeData

Definicja kolumny Coexistent4ICDID tabeli NFZEpisodeData

Name

Coexistent4ICDID

Code

Coexistent4ICDID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Coexistent5ICDID tabeli NFZEpisodeData

Definicja kolumny Coexistent5ICDID tabeli NFZEpisodeData

Name

Coexistent5ICDID

Code

Coexistent5ICDID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ComaRecoveryDT tabeli NFZEpisodeData

Definicja kolumny ComaRecoveryDT tabeli NFZEpisodeData

Name

ComaRecoveryDT

Code

ComaRecoveryDT

Data Type

DATE

Mandatory

No

Comment

Data wybudzenia ze spaczki


Kolumna RehabAdmissionDT tabeli NFZEpisodeData

Definicja kolumny RehabAdmissionDT tabeli NFZEpisodeData

Name

RehabAdmissionDT

Code

RehabAdmissionDT

Data Type

DATE

Mandatory

No

Comment

Data przyjecia do zakladu rehabilitacji


Kolumna AdmissionBedsores tabeli NFZEpisodeData

Definicja kolumny AdmissionBedsores tabeli NFZEpisodeData

Name

AdmissionBedsores

Code

AdmissionBedsores

Data Type

NUMBER(5)

Mandatory

No

Comment

Flaga czy pacjent mial odlezyny przy przyjeciu


Kolumna DischargeBedsores tabeli NFZEpisodeData

Definicja kolumny DischargeBedsores tabeli NFZEpisodeData

Name

DischargeBedsores

Code

DischargeBedsores

Data Type

NUMBER(5)

Mandatory

No

Comment

Flaga czy pacjent mial odlezyny przy wypisie


Kolumna RankinScale tabeli NFZEpisodeData

Definicja kolumny RankinScale tabeli NFZEpisodeData

Name

RankinScale

Code

RankinScale

Data Type

NUMBER(10)

Mandatory

No

Comment

Wartosc skali Rankina


Kolumna ScaldDegree tabeli NFZEpisodeData

Definicja kolumny ScaldDegree tabeli NFZEpisodeData

Name

ScaldDegree

Code

ScaldDegree

Data Type

NUMBER(10)

Mandatory

No

Comment

Wartosc skali poparzenia


Kolumna CardioLVef tabeli NFZEpisodeData

Definicja kolumny CardioLVef tabeli NFZEpisodeData

Name

CardioLVef

Code

CardioLVef

Data Type

NUMBER(5)

Mandatory

No

Comment

wartosc oceny funkcji skurczowej lewej komory/frakcji skracania lewej komory


Kolumna ICD9ID tabeli NFZEpisodeData

Definicja kolumny ICD9ID tabeli NFZEpisodeData

Name

ICD9ID

Code

ICD9ID

Data Type

NUMBER(10)

Mandatory

No

Comment

id procedury medycznej (ICD9)


Kolumna ICD10ID tabeli NFZEpisodeData

Definicja kolumny ICD10ID tabeli NFZEpisodeData

Name

ICD10ID

Code

ICD10ID

Data Type

NUMBER(10)

Mandatory

No

Comment

id diagnozy (ICD10)


Kolumna RehabilitationTypeID tabeli NFZEpisodeData

Definicja kolumny RehabilitationTypeID tabeli NFZEpisodeData

Name

RehabilitationTypeID

Code

RehabilitationTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

id typu rehabilitacji


Kolumna NyhaScaleID tabeli NFZEpisodeData

Definicja kolumny NyhaScaleID tabeli NFZEpisodeData

Name

NyhaScaleID

Code

NyhaScaleID

Data Type

NUMBER(10)

Mandatory

No

Comment

id ze slownika skali nycha


Kolumna NyhaScaleCode tabeli NFZEpisodeData

Definicja kolumny NyhaScaleCode tabeli NFZEpisodeData

Name

NyhaScaleCode

Code

NyhaScaleCode

Data Type

VARCHAR2(4)

Mandatory

No

Comment

kod pozycji ze skali nycha


Kolumna HasInfection tabeli NFZEpisodeData

Definicja kolumny HasInfection tabeli NFZEpisodeData

Name

HasInfection

Code

HasInfection

Data Type

NUMBER(10)

Mandatory

No

Comment

wystapienie zakazenia


Kolumna InfectionICDID tabeli NFZEpisodeData

Definicja kolumny InfectionICDID tabeli NFZEpisodeData

Name

InfectionICDID

Code

InfectionICDID

Data Type

NUMBER(10)

Mandatory

No

Comment

diagnoza rozpoznania zakazenia szpitalnego